module.exports = app => {
    const { STRING, INTEGER, DATE, BIGINT, TINYINT } = app.Sequelize;

    const Alumni = app.model.define('alumni', {
        id: {
            type: BIGINT.UNSIGNED,
            primaryKey: true,
            autoIncrement: true,
        },
        student_id: { type: STRING(20), allowNull: false },
        real_name: { type: STRING(20), allowNull: false },
        phone: { type: STRING(11), allowNull: false },
        grade: { type: STRING(10), allowNull: false },
        major: { type: STRING(50), allowNull: false },
        college: { type: STRING(50), allowNull: false },
        status: { type: TINYINT, allowNull: false, defaultValue: 1 },
        created_at: DATE,
        updated_at: DATE,
    }, {
        tableName: 'alumnis',
        timestamps: false,
    });

    return Alumni;
};